I found that using version 5.1 of the ODBC connector solved our problem with Chinese characters. It might solve the problem with the pound sterling sign.
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: John Trammell [mailto:[EMAIL PROTECTED] > Sent: Monday, September 24, 2007 10:30 AM > To: Critters; MySQL General > Subject: RE: Problem with characters > > > From: Critters [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 24, 2007 5:24 AM > > To: MySQL General > > Subject: Problem with characters > > > > I have a new setup with mySql version 4.1 and myODBC version 3.51 > > running on Windows 2k3 standard > > > > In the database we have something like "And this is £200" > and when we > > write this out in ASP we get "And this is ?200" The same happens for > > some other symbols like the copy write symbol (c in a circle) > > > > Any ideas? I have googled this for almost an hour now and never had > > this problem on other installs. > > I've found the following resources to be very helpful when > dealing with > character set issues: > > http://www.cs.tut.fi/~jkorpela/chars.html > http://www.joelonsoftware.com/articles/Unicode.html > > HTH, HAND > JT > > P.S. - Sorry for the earlier post with the abysmal > formatting. I claim > too much blood in my caffeine stream as an excuse. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
