Re: Visual Studio 2005 and Greek language

[Richard Creer]

This may or may not be the same problem but it is certainly similar except I've been experimenting with Russian.

My SQL update statement looks correct with a mixture of English and Russian characters but when I update the table the Russian characters are replaced with question marks.

If I type in Russian characters in QueryBrowser they appear as black blocks. When I retrieve them with an SQL select they are question marks.

So it would seem that Unicode characters are not being stored, but somebody out there must be using Unicode and MySQL successfully. What's the secret?

Table character set: utf8
MySQL 4.1.19
MyODBC 3.51.12
.Net Framework 2.0