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: mašalaitis
    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

« $_SESSION Use || Do x to items 1-7, then y... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home