Re: Problem with insertng values to varchar column

[Bryan Pendleton]

Eranda Sooriyabandara wrote:

ij> INSERT INTO table2 VALUES(`aa'),(`ab'),(`ac');

The message I got after fored exit,

ERROR 42X02: Lexical error at line 1, column 27. Encountered: "`" (96), after :

I think the mis-matched quotation marks caused the behavior that you see.

Try using only the single quotation mark (') for both the start and
end of the string, as in:

INSERT INTO table2 VALUES('aa'),('ab'),('ac');

thanks,

bryan