Re: display VARCHAR(mysql) and special chars in html

2005-02-23 Thread Wolfram Kraus
Jonas Meurer wrote: hello, my script selects a comment saved as VARCHAR in MySQL and displays it inside an html page. the problem is, that the comment contains several special characters, as mysterious utf-8 hyphens, german umlauts, etc. i could write a function to parse the comment and substitute

Re: display VARCHAR(mysql) and special chars in html

2005-02-23 Thread Radovan Garabik
Wolfram Kraus [EMAIL PROTECTED] wrote: Jonas Meurer wrote: hello, my script selects a comment saved as VARCHAR in MySQL and displays it inside an html page. the problem is, that the comment contains several special characters, as mysterious utf-8 hyphens, german umlauts, etc. i could

Re: display VARCHAR(mysql) and special chars in html

2005-02-23 Thread deelan
Jonas Meurer wrote: (...) i've changed my plans, and now will transform the comments to html before saving them in mysql. this way, the comment never contains special chars except they weren't filtered out when safed in mysql. do any filters exist, to transform plain text to html? otherwise i

Re: display VARCHAR(mysql) and special chars in html

2005-02-22 Thread Radovan Garabik
Jonas Meurer [EMAIL PROTECTED] wrote: hello, my script selects a comment saved as VARCHAR in MySQL and displays it inside an html page. the problem is, that the comment contains several special characters, as mysterious utf-8 hyphens, german umlauts, etc. i could write a function to

Re: display VARCHAR(mysql) and special chars in html

2005-02-22 Thread Jonas Meurer
On 22/02/2005 Radovan Garabik wrote: i could write a function to parse the comment and substitute special chars with the relevant html code, but maybe this already exists in some module? just make the page in utf-8, and you'll save you a lot of troubles ok, how do i do this? simply add a

Re: display VARCHAR(mysql) and special chars in html

2005-02-22 Thread Steve Holden
Jonas Meurer wrote: On 22/02/2005 Radovan Garabik wrote: i could write a function to parse the comment and substitute special chars with the relevant html code, but maybe this already exists in some module? just make the page in utf-8, and you'll save you a lot of troubles ok, how do i do this?

display VARCHAR(mysql) and special chars in html

2005-02-21 Thread Jonas Meurer
hello, my script selects a comment saved as VARCHAR in MySQL and displays it inside an html page. the problem is, that the comment contains several special characters, as mysterious utf-8 hyphens, german umlauts, etc. i could write a function to parse the comment and substitute special chars