[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
UTF8 issue
Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore
-
- VIP Livecode Opensource Backer
- Posts: 1005
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
- Contact:
UTF8 issue
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
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
-
- VIP Livecode Opensource Backer
- Posts: 1005
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
- Contact:
Re: UTF8 issue
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.
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
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