Posted by Squet34785 on 10/09/06 20:57

Hello,
A bit off topic as it's about MySQL but I thought someone here would know
the answer.
I imported a list of records into my database from a tab delimited file, and
where some columns should be null or empty strings the associated PHP script
is treating them as valid entries. If I try to view the column:

mysql> select variantspelling from works where uid2=12777;
+-----------------+
| variantspelling |
+-----------------+
|
+-----------------+
1 row in set (0.00 sec)

It appears to be a newline, as I can pull it out in PHP and wrap it with
some characters and it only seems to a newline character. However the
following doesn't work:

mysql> select variantspelling from works where variantspelling regexp '\n'
and uid2=122777;
Empty set (0.00 sec)

Nor does

mysql> select variantspelling from works where variantspelling regexp '\n\r'
and uid2=122777;
Empty set (0.00 sec)

Does anyone know what the characters might be and how to identify them in
the database so I can mark them as null?

• Next in forum: Re: problem getting strip_tags to strip tags
• Prev in forum: help needed w/prize draw script
• Thread view: OT: Odd chars in MySQL column

[Reply to this message]