<p><font size="2">I'm using 1.10.0 beta 2 -- the one that comes with EnterpriseDB 8.4 beta1.<br /><br /> When I try to
createa new database and specify the collations and character type I get error something to the effect syntax error in
collate.<br/><br /> Looking at the SQL its generating<br /><br /> CREATE DATABASE testpg84<br /> WITH
ENCODING='UTF8'<br/> TEMPLATE=template0<br /> COLLATE='C'<br /> CTYPE='English_United
States.1252'<br/> CONNECTION LIMIT=-1;<br /><br /> Shouldn't that be<br /><br /> LC_COLLATE<br /> LC_CType<br
/><br/> according to the docs<br /><a
href="http://www.postgresql.org/docs/8.4/static/sql-createdatabase.html">http://www.postgresql.org/docs/8.4/static/sql-createdatabase.html</a><br
/><br/> If I hand create as<br /><br /><br /> CREATE DATABASE testpg84<br /> WITH ENCODING='UTF8'<br />
TEMPLATE=template0<br/> LC_COLLATE='C'<br /> LC_CTYPE='English_United States.1252'<br />
CONNECTIONLIMIT=-1;<br /><br /> works fine<br /><br /> Thanks,<br /> Regina<br /><br /></font><p><hr size="1"
/><p><strong>The substance of this message, including any attachments, may be confidential, legally privileged and/or
exemptfrom disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in
error,please contact the sender and delete the material from any computer. </strong><p><hr size="1" /><p><strong><font
color="339900"size="2"> Help make the earth a greener place. If at all possible resist printing this email and join us
insaving paper. </font></strong><p>
