Re: utf8 still creates broken chars

2006-10-26 Thread Paul Warner
>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

utf8 still creates broken chars

2006-10-26 Thread Paul Warner
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

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite - FIXED

2006-10-20 Thread Paul Warner
- 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

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite - FIXED

2006-10-20 Thread Paul Warner
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:

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite

2006-10-19 Thread Paul Warner
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

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite

2006-10-19 Thread Paul Warner
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

£ (Great Britain Pound) breaks MySQL insert and u pdate - disastrous overwrite

2006-10-19 Thread Paul Warner
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