AW: Unicode: LC 7.0 - PHP - MySQL?

[Tiemo Hollmann TB]

Thanks Peter

> -----Ursprüngliche Nachricht-----
> Von: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] Im
Auftrag
> von Peter W A Wood
> Gesendet: Donnerstag, 30. Oktober 2014 13:11
> An: How to use LiveCode
> Betreff: Re: Unicode: LC 7.0 - PHP - MySQL?
> 
> Hello Tiemo
> 
> > On 30 Oct 2014, at 16:30, Tiemo Hollmann TB <toolbook at kestner.de> wrote:
> >
> > Hello Peter,
> > thank you for taking your time for your helpful explanations. I still
> > have two issues left.
> > I found in the SQL export of my db that it is UTF-8 encoded. So
> > perhaps the definition of a collation "ascii_general_ci" defines a
"subset"
> of UTF-8?
> 
> True ASCII (the first 128 characters which includes A-Z and a-z but not é,
ü,
> etc) is a genuine subset of UTF-8. From a quick web search, it seems the
_ci
> refers to case insensitive collation so that "A" and "a" are treated the
same.
> 
> > As far as I understand it now, I should pass all LC strings with
> > uniEncode(string,UTF8) to the PHP because of the UTF-8 of MySQL.
> > Probably I will fiddle around with uniEncode/uniDecode at the
> > interface to the PHPs and see with which encode parameter the correct
string
> gets into the MySQL db.
> >
> > On the other side I am importing data from a Valentina-DB. Where I
> > have to set the Encoding to Macintosh / Latin, depending on the
> > platform. Does this platform related conversion gets obsolete with LC
> > 7 UniCode, or is this still valid, because of data coming from
> > outside, though Valentina probably also is Unicode.
> 
> From their website, it seems that Valentina uses the same 'C library' as
> LiveCode (LibICU) and stores text UTF-16 encoded. In theory, you shouldn't
> need to convert text passing between the two but it may be different in
> practice.
> 
> Hope this helps.
> 
> Peter
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode