Add citext datatype support in PostgreSQL

6 posts, 0 answers
  1. Stanislaw
    Stanislaw avatar
    11 posts
    Member since:
    Sep 2008

    Posted 06 Jul 2011 Link to this post

    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

  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 12 Jul 2011 Link to this post

    Hello Stanislaw,
     
     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!

  3. DevCraft banner
  4. Stanislaw
    Stanislaw avatar
    11 posts
    Member since:
    Sep 2008

    Posted 03 Nov 2011 Link to this post

    Hi guys!
    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
  5. Ady
    Admin
    Ady avatar
    589 posts

    Posted 07 Nov 2011 Link to this post

    Hi Stanislaw,

    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!

  6. Stanislaw
    Stanislaw avatar
    11 posts
    Member since:
    Sep 2008

    Posted 27 Nov 2011 Link to this post

    Hi guys!
    Any update on this?
    Workaround or sample?
  7. Ady
    Admin
    Ady avatar
    589 posts

    Posted 28 Nov 2011 Link to this post

    Hi Stanislaw,

     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!

Back to Top
DevCraft banner