Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Storing "default" as a value
Not sure if this is what you're looking for, but if you have a column's default value set, like, for example: ColumnName CHAR(100) NOT NULL DEFAULT 'omglol' -- the default value will only be used if you insert a null (or nothing) to this column. Anything other than null will be entered into the... -
fulltext search using different collation
Hello all, I'm running MySQL 5.0.41. I have a table with its charset set to utf8, collated to utf8_bin. I'm using utf8_bin because I need case-sensitive unique values in a specific column. I'd like to perform a case- insensitive fulltext search on this particular column. I've created a fulltext...
