LiveCode Forums

[This post is an archive from old SQL Yoga forums]

Hi,

I have an strange issue that I don't know why is happening.
I have a database encoded as UTF8 and collation to ci_general_utf8. I query this database using SQL Yoga and show the records into a datagrid as UTF8 correctly.

Now I have other database with the same configuration, but when I try to perform the same, show records into a datagrid, the data don't appear correctly. Only appear correctly if before the query I exec a "SET NAMES 'UTF8'", then all the data is showed fine.

Why in the first database I don't need exec the SET NAMES UTF8 ?

Then I tryed to exec another query without exec the SET NAMES UTF8 and then the records appear correctly! I don't understand why...

Any idea? I can specify in some property of SQL Yoga the SET NAMES UTF8?

I need exec before the this command?

The both databases are in the same server.

Salut,

Josep M

Josep,

Unfortunately I'm not sure why your database would be behaving this way. SQL Yoga doesn't have any property that will add the SET NAMES 'UTF8' text to the query.