UTF8 issue

This is the place to post technical queries about SQL Yoga

Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore

Post Reply
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

UTF8 issue

Post by trevordevore » Fri Oct 11, 2013 1:59 pm

[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
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: UTF8 issue

Post by trevordevore » Fri Oct 11, 2013 1:59 pm

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.
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

Post Reply

Return to “SQL Yoga”