lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]


On Tue, May 12, 2009 at 11:57 AM, Marco Antonio Abreu
<mabreu.ti@gmail.com> wrote:
> 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.

Probably not garbage, it sounds like some code along the way is
converting latin1 to utf-8.

If you posted the hex values of the "garbage" string along with what
you expect it would be possible to tell what is happening.

Where the conversion is occuring is another story, could be in the
interface to the sql servers, or in luasql.

Sam