John Bokma wrote:
> "T.J." <no1@home.invalid> wrote:
>
>> "John Bokma" <john@castleamber.com> wrote in message
>> news:Xns9A15B5BAC2DDEcastleamber@130.133.1.4...
>>> "T.J." <no1@home.invalid> wrote:
>>>
>>>> ASP from MySQL database {MySQL ODBC 3.51 Driver}
>>>> Individual people submit their own details
>>> And there is probably where things go wrong. People copy & paste utf-8
>>> data into your form, and then there are many places stuff can go wrong:
>>>
>>> - the form handling code can't handle utf-8
>>> - the database columns don't support utf-8
>>> - the "print" code doesn't handle utf-8
>>>
>> Yes, I thought it was the way people were copying & pasting
>> in to the submission form, but don't understand why it
>> displays OK on one page but not another.
>>
>> Also, the problem has only arisen since changing from using
>> an Access database and since using a different host.
>> Is it likely to be something my host can put right by changing
>> things, or will I have to check all new listings and edit those
>> which are using bad characters?
>
> If your columns in MySQL aren't able to handle utf-8 then there isn't much
> you can do afaik. Unless you want to handle the form in utf-8 and remap
> all special characters (probably doable, but sounds like a lot of work).
>
> What kind of software are you using (i.e. the part that gets the input and
> stores it into mysql and back again)?
>

MySQL handles UTF-8 just fine. You just need to tell it you're using
UTF-8 (and, of course, feed it proper UTF-8 characters).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================