Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: Case Insensitive Database

Posted on 2010-08-24 20:43:39 by pozer

This is a multi-part message in MIME format.

------_=_NextPart_001_01CB43BC.8FE08B82
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I currently have a mysql database that is case insensitive. Is it
possible to set up a case insensitive database in PostgressQl? So far
it doesn't look like it. And if it is possible what are the variables I
need to set?=20

Thanks

=20

Pam Ozer






------_=_NextPart_001_01CB43BC.8FE08B82
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
..MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DWordSection1>

<p class=3DMsoNormal>I currently have a mysql database that is case
insensitive.&nbsp; Is it possible to set up a case insensitive database =
in
PostgressQl?&nbsp; So far it doesn&#8217;t look like it.&nbsp; And if it =
is
possible what are the variables I need to set? <o:p></o:p></p>

<p class=3DMsoNormal>Thanks<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<div id=3Dcontent>

<p class=3DMsoNormal><b><span =
style=3D'font-size:11.5pt;font-family:"Arial","sans-serif";
color:black'>Pam Ozer<o:p></o:p></span></b></p>

</div>

<p class=3DMsoNormal><span style=3D'font-size:12.0pt;font-family:"Times =
New Roman","serif"'><br>
<br>
</span><o:p></o:p></p>

</div>

</body>

</html>

------_=_NextPart_001_01CB43BC.8FE08B82--

Report this message

#2: Re: Case Insensitive Database

Posted on 2010-08-24 21:10:31 by Scott Marlowe

On Tue, Aug 24, 2010 at 12:43 PM, Ozer, Pam <pozer@automotive.com> wrote:
> I currently have a mysql database that is case insensitive.=A0 Is it poss=
ible
> to set up a case insensitive database in PostgressQl?=A0 So far it doesn=
=92t
> look like it.=A0 And if it is possible what are the variables I need to s=
et?

You can use the contrib module for citext types.

--=20
To understand recursion, one must first understand recursion.

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Report this message