>Haven't read your issue in its entirety, but UTF-8 can definitely
>handle these characters.
>The prob is either in the DB, the app, or the tomcat config.
>
>1. The DB: Make absolutely sure that the content in the db is in fact UTF-8.
>
>One thing I've done in the past to verify this exact issue, i
Hi,
I thought my utf8 settings on my database and tomcat were effective, but I am
still getting ? characters instead of the real thing, even for simple things
like latin extended-A, and even some latin-1 characters are broken. Any ideas?
Here is some text as entered, and as returned by my Java
- Original Message
From: Paul Warner <[EMAIL PROTECTED]>
To: Philip Mather <[EMAIL PROTECTED]>; MySQL List
Sent: Friday, October 20, 2006 4:14:44 PM
Subject: Re: £ (Great Britain Pound) breaks MySQL insert and update -
disastrous overwrite - FIXED
Thanks, Warren and Phil for yo
rom this thread.
Regards,
Paul
- Original Message
From: Philip Mather <[EMAIL PROTECTED]>
To: MySQL List
Sent: Friday, October 20, 2006 2:24:18 PM
Subject: Re:£ (Great Britain Pound) breaks MySQL insert and update - disastrous
overwrite
Warren Young wrote:
> Paul Warner wrote:
e advert set adverttitle='jobs pages', mainbody='idiotic stuff £50605
blahblahblah...', forfurtherinfo='contact Paul Warner, MISD
editing this text.', finalcopy='RESEARCH ARTISTManagement
Information Services Division
Salary: £28,930.00-£50,219.00 paidiotic stuff
his?? I'm going mad.
Thanks,
Paul
- Original Message
From: Paul Warner <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Thursday, October 19, 2006 11:03:15 AM
Subject: £ (Great Britain Pound) breaks MySQL insert and update - disastrous
overwrite
Hello,
I have a Java Struts ap
Hello,
I have a Java Struts application running on Tomcat 5. I have mysql 5 installed
on redhat EL 3. When a user enters text with a £ sign (Great Britain Pound) in
the browser and clicks enter, any insert or update statement apparently gets
truncated in mysql. The insert reliably breaks and