[Date Prev][Date Next][Thread Prev][Thread Next]
- Subject: Re: code page
- From: Tomas Guisasola Gorham <tomas@...>
- Date: Tue, 12 May 2009 16:19:28 -0300 (BRT)
I made a script using LuaSQL to syncronize two databases, one is a MS SQL
Server 2008 and the other is a My SQL 5.0. It works well except for the
accents (á, é, ç ...). When a field have any accented character it is copied
like some garbage (two bytes for each accented char) and truncate the final
characters. Both MS SQL and MySQL are with "Latin1" code page. I know Lua is
8 bit based. Do you know how to resolve this?
I have been using latin1 accents with Postgres for years
and it works perfectly. Can't say much about MySQL or SQL Server.