Page 1 of 1

String Help

Posted: Wed Dec 15, 2010 8:58 am
by mirana
Does anyone know is * is a string?
if I define a variable ad `package` text collate latin1_general_ci NOT NULL, ; Can I assign * to that package?

if I can't then How do I need to initialize in SQL?

Thank you

Re: String Help

Posted: Wed Dec 15, 2010 9:20 am
by Apollo
Sure, as long as you quote it.

Code: Select all

INSERT INTO your_table (package) VALUES ('*')

Re: String Help

Posted: Wed Dec 15, 2010 10:33 am
by mirana
Thanks :)