![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Sat, Aug 3 2013 10:01 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | I don't know if this is possible but, I was going to add Barry's justification functions into my database and realised I have to change the collation. I think most people are simply going to use whatever their default collation is.
Would it be possible to have a default collation defined for the database and then simply use that? This would make things more portable (functions, procedures, table definitions?) Roy Lambert |
Sat, Aug 3 2013 1:30 PM | Permanent Link |
Uli Becker | Roy,
> Would it be possible to have a default collation defined for the database and then simply use that? Do you mean this: EDBManager File | Preferences | Dialogs ? Uli |
Sun, Aug 4 2013 5:11 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Uli
>> Would it be possible to have a default collation defined for the database and then simply use that? > >Do you mean this: > >EDBManager >File | Preferences | Dialogs Good try but no ![]() From Barry's post CREATE FUNCTION "LeftJustify" (IN "aValue" VARCHAR COLLATE UNI_CI, IN "aWidth" INTEGER, IN "aFillChar" CHAR(1) COLLATE UNI_CI) What I'd like is CREATE FUNCTION "LeftJustify" (IN "aValue" VARCHAR, IN "aWidth" INTEGER, IN "aFillChar" CHAR(1)) Its trivial for me to alter the UNI_CI to ANSI_CI on each individual occasion, and its forced when I try and install in my non-unicode EDBManager but if a (to me) weird collation was used that did exist it could have "interesting" consequences - what I'm not sure but that's part of the problem. Roy |
Sun, Aug 4 2013 8:30 AM | Permanent Link |
Uli Becker | Roy,
Ok I misinterpreted that. Uli |
Tue, Aug 6 2013 12:40 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< Would it be possible to have a default collation defined for the database and then simply use that? >> Yes. It's actually already in the database catalog and Databases system table, but not implemented in the CREATE/ALTER DATABASE statement yet. BTW, you can leave off the COLLATE clause now, it's just that the collation will default to ANSI or UNI, depending upon the version being used. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |