ASCII Convert issue
Date: 04/16/10
(PHP Community) Keywords: php, database, sql
I have a person's name with a non-standard ascii character in it (š) and am having trouble converting to back to ascii to retrieve their record.
The url string contains: maalaitis
But PHP reads it as: mašalaitis
So, my SQL is basically not finding what is stored in the database (former) with what the querystring contains (latter). I'm trying to use ORD() based on the specific value that š outputs (154) and add to the beginning, and ; after.
But, this is what it shows when I loop through the whole name:
109 = m
97 = a
197 = �
161 = �
97 = a
108 = l
97 = a
105 = i
116 = t
105 = i
115 = s
Any help is greatly appreciated.
Source: http://php.livejournal.com/677993.html