The citext type provides a case-insensitive character string type. I have a requirement to use this type in almost all string properties of my application. This requirements based on next rules:
- all searches that includes string properties must be case-insensitive
- checking for the uniqueness also must be case-insensitive
The MS SQL Server provides nvarchar case-insensitive type by default, the PostgreSQL supports this by external module citext.
I'm already implemented citext support in Npgsql data provider and have it working with NHibernate. But I'm seriously considering development with OpenAccess and need support of citext datatype
5 Answers, 1 is accepted
We will look into the effort of providing support for this type and provide adequate information on how to use it.
We will keep you posted.
Greetings,
Ady
the Telerik team
Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!
Rank 1
Is there any update for this?
I still need support of citext data type.
May be I can implement it myself if you give me a right direction or sample
Unfortunately this has not made it into the product yet. I am giving it a try now and will try and provide you with some hints on how you could implement support for it on your own,if possible.
Greetings,
Ady
the Telerik team
NEW and UPDATED OpenAccess ORM Resources. Check them out!
Rank 1
Any update on this?
Workaround or sample?
You would need to implement a type converter for the citext data type and then specify that this converter be used when reading data from the column. You can find a detailed example on how to achieve this, here.
Do get back in case you need assistance in achieving this.
Greetings,
Ady
the Telerik team
Q3’11 of Telerik OpenAccess ORM is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!