Re: } character

[Benjamin Pflugmann]

Hi.

I cannot reproduce this problem (MySQL 3.22.16a):

mysql> insert into blacklist values ('}');
Query OK, 1 row affected (0.04 sec)

mysql> CREATE TABLE test1 (
    ->   title VARCHAR(50) NOT NULL,
    ->   abitrary INT     
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT INTO test1 (title) VALUES ('}');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM test1;
+-------+----------+
| title | abitrary |
+-------+----------+
| }     |     NULL |
+-------+----------+
1 row in set (0.00 sec)

So please, as Martin pointed out, give more information. Best is to
give a full test case (as I did) with every input an output, which
shows the error, the MySQL version you use and so on.

Bye,

        Benjamin.


On Fri, Aug 13, 1999 at 10:01:49AM +0200, martin.edelius@stripped wrote:
[...]
> If this is all the info you're going to provide I don't think anyone
> will be able to help out. 8)
> 
> What is the exact error?
> What does your table look like (Content) in this case?
> 
> I don't think that } needs to be escaped, atleast I've never needed to
> escape it...

[...]
> -----Ursprungligt meddelande-----
[...]
> I tried to add a field with '}' as value as follows:
> 
> INSERT INTO Content
> (ctImgURL,ctDescEn,ctLen,ctRelDate,ctFileSize,ctTitleZhTW,ctStartTm,ctUR
> L,ctLog,ctType,ctSlideURL,ctLang,ctEndTm,ctDescZhTW,ctTitleEn) VALUES
> ('','','','','','}','','','','0','','0','','','')
> 
> mySQL return syntax error. Anybody know why?