CSV pain and suffering with punctuation and non-ASCII characters

2009-12-14 Thread Jan Steinman
was TEXT. Changing it to BLOB preserves non-ASCII characters, but I still see the strange behaviour noted above with a single quote, which was in a VARCHAR(256) UTF8 field. Thanks for whatever help you can offer! My pants just went on a wild rampage through a Long Island Bowling Alley

RE: CSV pain and suffering with punctuation and non-ASCII characters

2009-12-14 Thread Neil Aggarwal
Jan: For example, importing a quote with a Context field of: The Hitchhiker's Guide to the Galaxy results in a field containing: The Hitchhiker You are going to have to escape quotes, so your string should look like this: The Hitchhiker\'s Guide to the Galaxy See this

finding non-ascii characters within a string

2007-10-18 Thread Olav Mørkrid
hello i would like to search a table column for a range of non-ascii characters, or a particular non-ascii character. how can i do this? the column can be any string like hello, world or norwegian characters æøå here. refer to these pseudo examples: SELECT * FROM TABLE WHERE COLUMN CONTAINS

Re: finding non-ascii characters within a string

2007-10-18 Thread Baron Schwartz
Hi, Olav Mørkrid wrote: hello i would like to search a table column for a range of non-ascii characters, or a particular non-ascii character. how can i do this? the column can be any string like hello, world or norwegian characters æøå here. refer to these pseudo examples: SELECT * FROM

Re: finding non-ascii characters within a string

2007-10-18 Thread Ralf Hüsing
Olav Mørkrid schrieb: hello i would like to search a table column for a range of non-ascii characters, or a particular non-ascii character. how can i do this? Maybe via a inverted regular expression [1] like this?: SELECT * FROM TABLE WHERE COLUMN RLIKE '[^-, a-zA-Z0-9]' [1]: http

Re: Filtering non-ascii characters from mysql data, null, tab etc

2005-02-13 Thread zzapper
On Fri, 11 Feb 2005 18:41:38 -0500, wrote: zzapper wrote: On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote: Tom adapting your script, create table test (txt varchar(255)) Type=MyISAM; insert into test values('Some Text\nand some more'); update test set txt = replace(txt,'\n','');

Re: Filtering non-ascii characters from mysql data, null, tab etc

2005-02-11 Thread Thomas Spahni
What about the following? mysql create table test (txt varchar(255)) Type=MyISAM; Query OK, 0 rows affected (0.00 sec) mysql insert into test values('Some Text\0and some more'); Query OK, 1 row affected (0.00 sec) mysql select * from test; *** 1. row

Re: Filtering non-ascii characters from mysql data, null, tab etc

2005-02-11 Thread zzapper
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote: Tom adapting your script, create table test (txt varchar(255)) Type=MyISAM; insert into test values('Some Text\nand some more'); update test set txt = replace(txt,'\n',''); BTW \n = null \0 seems to be something else Turns out my rotten

Re: Filtering non-ascii characters from mysql data, null, tab etc

2005-02-11 Thread zzapper
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote: Tom adapting your script, create table test (txt varchar(255)) Type=MyISAM; insert into test values('Some Text\nand some more'); update test set txt = replace(txt,'\n',''); BTW \n = null \0 seems to be something else Turns out my rotten

Re: Filtering non-ascii characters from mysql data, null, tab etc

2005-02-11 Thread Michael Stassen
zzapper wrote: On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote: Tom adapting your script, create table test (txt varchar(255)) Type=MyISAM; insert into test values('Some Text\nand some more'); update test set txt = replace(txt,'\n',''); BTW \n = null \0 seems to be something else Turns out my

Filtering non-ascii characters from mysql data, null, tab etc

2005-02-10 Thread zzapper
Hi, I've successfully used the following update-replace statement to replace strings in mysql data update tbl_county_lookup set countyname=replace(countyname,'amp;','and') ; However I've had problems trying to replace a null character 0x00h , I'd be interested to know the syntax to filter

Re: Filtering non-ascii characters from mysql data, null, tab etc

2005-02-10 Thread zzapper
On Thu, 10 Feb 2005 10:17:00 +, wrote: Hi, I've successfully used the following update-replace statement to replace strings in mysql data update tbl_county_lookup set countyname=replace(countyname,'amp;','and') ; However I've had problems trying to replace a null character 0x00h , I'd

non-ASCII characters in LIKE and regexp comparisons?

2003-12-23 Thread Markus S. Hasler
Hi mysql-list, 1. my installation: [EMAIL PROTECTED]:~ uname -a Linux rosetta 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown [EMAIL PROTECTED]:~ mysql show global variables like version; +---++ | Variable_name | Value |

RE: Non Ascii characters

2001-10-04 Thread Andrew Murphy
Hi, Have you tried escaping the euro character '\€', maybe that would work for you. Andrew Murphy -Original Message- From: Jamie Smith [mailto:[EMAIL PROTECTED]] Sent: 03 October 2001 11:23 am To: Mysql@Lists. Mysql. Com Subject: Non Ascii characters I'm having a problem

RE: Non Ascii characters

2001-10-03 Thread Haapanen, Tom
]] Sent: 03 October 2001 06:23 To: Mysql@Lists. Mysql. Com Subject: Non Ascii characters I'm having a problem with the sending of the new euro € symbol into the mysql database through a standard SQL stament. I have tried everything cut and paste or ALT 0128 on the command line but all I seem to get

Re: Non Ascii characters

2001-10-03 Thread Doc Nielsen
, October 03, 2001 1:15 PM Subject: RE: Non Ascii characters Jamie, This is likely a client software issue. We use Perl and DBI, and we have no trouble storing or retrieving non-USASCII characters. What are you using to access the MySQL database? Tom Haapanen [EMAIL PROTECTED] -Original