Can not update text with Polish characters.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eurofirms. - 28 Mar 2007 13:02 GMT

I have a table where there are translations of various strings into different
languages. I need to load this strings and allow some users to modify and
update the strings back into the table.

When I load a text written in polish, the application loads the data
correctly and the user see all the characters in polish, but when the
application writes back the string into the database, a word like wysokośći
is converted into wysokosci.

I tried to change the culture of the thread that executes the update to
pl-PL (Polish) but the bug remains. Is there some way I can tell ADO.NET to
preserve the language of the string when updated to the table?

Reply to this Message

Cor Ligthert [MVP] - 29 Mar 2007 06:30 GMT

At least needs all the systems the right codepage, it seems the clients have
them while the server has another one.

http://www.microsoft.com/globaldev/reference/sbcs/1250.mspx

from not so a small man

Cor

>I have a table where there are translations of various strings into
>different
[quoted text clipped - 11 lines]
> to
> preserve the language of the string when updated to the table?

Reply to this Message

Eurofirms. - 29 Mar 2007 08:54 GMT

I don't think that the problem is the codepage. If I enter the text directly
to the Database through enterprise manager, the text is correctly saved. The
problem appears when I try to update the text through ADO.NET, so I think the
problem is in the ADO connection.

Is there some parameter or procedure to define the language used in the
connection?.
If I debug the program, the string is correctly passed through all levels to
the SQLCommand.ExecuteNonQuery() procedure, but I can’t debug at this point.

> At least needs all the systems the right codepage, it seems the clients have
> them while the server has another one.
[quoted text clipped - 20 lines]
> > to
> > preserve the language of the string when updated to the table?

Reply to this Message

Milosz Skalecki [MCAD] - 29 Mar 2007 20:58 GMT

Uszanowanie ;-)

Run SQL Server Profiler and see what is being executed. It should help you
to identify on which side (ADO.NET or SQL collation problems) causes the
problem(more likely).

Hope this helps

Signature

Milosz

> I don't think that the problem is the codepage. If I enter the text directly
> to the Database through enterprise manager, the text is correctly saved. The
[quoted text clipped - 30 lines]
> > > to
> > > preserve the language of the string when updated to the table?

Reply to this Message

Can not update text with Polish characters.

Free Magazines