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
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
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
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
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
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','');
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
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
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
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
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
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
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 |
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
]]
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
, 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
16 matches
Mail list logo