By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

custom collating sequence

P: n/a
Hi

We want to create case-insensitive database (DB2 8.2.2 Win) . I found
information we need create custom collating sequence and create database
with this sequence but I can't find informations how do this.

Can anyone tell me how create case-insensitive collating sequence
(sample or link) and how set this sequence in CREATE DATABASE command?

Thanks in advance.
Yaro
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Yaro wrote:
Hi

We want to create case-insensitive database (DB2 8.2.2 Win) . I found
information we need create custom collating sequence and create database
with this sequence but I can't find informations how do this.

Can anyone tell me how create case-insensitive collating sequence
(sample or link) and how set this sequence in CREATE DATABASE command?

Thanks in advance.
Yaro

No can do. You can create a user defined collation, but each character
in the end will be unique.
If you want specfic columns to be case-insensive for searching take a
look at generated columns.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.