MySQL Forums
Forum List  »  Delphi

Delphi 2010, Unicode and MySQL 5.0
Posted by: Dan Kelly
Date: November 19, 2009 11:09AM

Hi

We're currently in the process of migrating all our Delphi apps to Delphi 2010, and this means moving to Unicode as default.

Specifically we are having problems with the GBP currency symbol ("£") which is being written into our tables as "£".

I think that the problem is that Delphi is sending a Unicode String to the database, which is instead expecting an Ansi string.

Our default charset is latin1.

However, if we change the charset on a table to either utf8 or ucs2 we still get the same problem...

Any help?

Also, assuming that the solution is to change the charset on the database, how much of an issue will it be?

Thanks Dan

Options: ReplyQuote


Subject
Written By
Posted
Delphi 2010, Unicode and MySQL 5.0
November 19, 2009 11:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.