Skip to content

Instantly share code, notes, and snippets.

@tijn

tijn/gist:822145

Created February 11, 2011 09:46
Show Gist options
  • Save tijn/822145 to your computer and use it in GitHub Desktop.
Save tijn/822145 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
show lc_collate;
lc_collate
-------------
en_US.UTF-8
(1 row)
soocial_test=# select lower(''), upper(''), lower('ble, trret'), upper('ble, trret'), lower('LUT K'), upper('lut '), lower('');
lower | upper | lower | upper | lower | upper | lower
-------+-------+------------+------------+-------+-------+-------
| | ble, trret | BLE, TRRET | lut k | LUT |
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment