Applies to:
PHP 5.4
MySQL 5.1.4
Databases initially setup with collation 'latin1_swedish_ci'
What
Another article trying to help people display foreign characters on their website without ...
... sequence operator in any regular expression where collation is needed. For example, to specify the range from 'a' to 'ch', you can use the following expression:
[a-[.ch.]]
POSIX Character Equivalence ...
...
Method #3
And a further enhancement which lists the different datatypes, is_nullable, maxlength and collations side-by-side:
-- all columns side by side
SELECT
t1.TABLE_CATALOG AS [DB1_Name],
t2.TABLE_CATALOG ...
What?
Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the ...
... the collation of the SQL Server being case-insensitive.
What?
End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the ...
... eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive.
Furthermore, we now have the task of finding all the variations of ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.