Spanish Characters not showing under C++ builder App

spetzbal · Post by **spetzbal** » Mon 13 Oct 2008 18:18

Hi:

The spanish characters like Ñ, accents, etc. cannot be seen properly on a Windows Application based on CRLAB MySql Connector!!.
The funny thing is that if i query the table on the console mode one can see the characters properly!!

What i need to do to fix this problem?

Challenger · Post by **Challenger** » Wed 15 Oct 2008 11:38

Perhaps the charset of the saved data does not correspond the charset used in Windows. Note that the charset in console application is not the same as in standard one.

spetzbal · Post by **spetzbal** » Thu 16 Oct 2008 00:03

thanks a lot but where can i check and reconfigure that on CRLAB driver or mysql db, o C++ where?

Challenger · Post by **Challenger** » Thu 16 Oct 2008 08:05

We suggest you to convert the data in your database. Otherwise, you should convert every value from DOS(OEM) charset to Windows charset.

spetzbal · Post by **spetzbal** » Thu 16 Oct 2008 17:41

thanks a lot again.

Sorry for bothering so much.
But please just a sample of how i convert my data.
I use sql insert scripts, since the data is generated on another database, i use ms access on the other db, and there i don't have any kind of this problems, i am using mysql since it is a school project!!.
what do i need to do to make that convertion that you are talking about?

Thanks.