Project

General

Profile

Activity

From 06/27/2021 to 07/26/2021

07/26/2021

07:05 PM Feature #5491: custom locale/collation implementations
In "Loading a Custom TimeZone Provider in Java 8":https://stackoverflow.com/questions/58937553/loading-a-custom-timez... Greg Shah
03:09 PM Feature #5491: custom locale/collation implementations
Greg Shah wrote:
> I agree this would be preferred. On the other hand, I wonder if there is a way to eliminate this...
Ovidiu Maxiniuc
02:49 PM Feature #5491: custom locale/collation implementations
> Is this best scripted into @install_spawner.sh@ (even though that name wouldn't be accurate)?
No, this is too c...
Greg Shah
02:32 PM Feature #5491: custom locale/collation implementations
I do not think this is a problem: @p2jspi.jar@ will provide @en_US_P2J@ via @P2JCollatorProvider@ and @fwdspi.jar@ wi... Ovidiu Maxiniuc
02:32 PM Feature #5491: custom locale/collation implementations
I'd like a "safe" way to update the @fwdspi.jar@ file. Is this best scripted into @install_spawner.sh@ (even though t... Roger Borrello
02:28 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> Ovidiu Maxiniuc wrote:
> > Is this a good time to rename @p2jspi.jar@ to @fwdspi.jar@?
>
...
Constantin Asofiei
02:17 PM Feature #5491: custom locale/collation implementations
We can't just search and replace. We must leave the older docs in place and just explain the difference starting wit... Greg Shah
02:01 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> Is this a good time to rename @p2jspi.jar@ to @fwdspi.jar@?
I don't have an objection, b...
Eric Faulhaber
01:53 PM Feature #5491: custom locale/collation implementations
Is this a good time to rename @p2jspi.jar@ to @fwdspi.jar@? Ovidiu Maxiniuc
04:15 AM Support #5183 (Review): database collation
This issue became primarily about documenting the differences in database collation between the legacy environment an... Eric Faulhaber

07/23/2021

02:13 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> So long as the locale definitions are in place in @/usr/share/i18n/locales@ and the required...
Ovidiu Maxiniuc
02:10 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > If it is true - this is really great news!
> Yes, exactly.
> ...
Eric Faulhaber
02:04 PM Feature #5491: custom locale/collation implementations
Eugenie Lyzenko wrote:
> If it is true - this is really great news!
Yes, exactly.
Here a quote from @man locale-ge...
Ovidiu Maxiniuc
01:59 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> @sudo locale-gen --no-purge --no-archive@
> in order to keep old locales (like @en_US@p2...
Eric Faulhaber
01:58 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> 2. and 3. do the same thing. In this case they can be used mutually exclusive.
> I would g...
Eugenie Lyzenko
01:52 PM Feature #5491: custom locale/collation implementations
2. and 3. do the same thing. In this case they can be used mutually exclusive.
I would go for 2. because once our lo...
Ovidiu Maxiniuc
01:49 PM Feature #5491: custom locale/collation implementations
Eugenie Lyzenko wrote:
> Roger Borrello wrote:
> > I want to be _future proof_... I love that term!
> >
> > So I...
Eric Faulhaber
01:36 PM Feature #5491: custom locale/collation implementations
Eugenie Lyzenko wrote:
> This is not required. Moreover I think it is better to keep the file @/etc/locale.gen@ free...
Roger Borrello
01:31 PM Feature #5491: custom locale/collation implementations
Roger Borrello wrote:
> I want to be _future proof_... I love that term!
>
> So I will perform:
> # ...
> # add...
Eugenie Lyzenko
01:11 PM Feature #5491: custom locale/collation implementations
I want to be _future proof_... I love that term!
So I will perform:
# @sudo cp <p2j>/locale/en_GB&#64;iso88591_fw...
Roger Borrello
12:47 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> If the dialect is not H2, the @embedded-collation@ settings under respective database node ...
Eric Faulhaber
12:13 PM Feature #5491: custom locale/collation implementations
If the dialect is not H2, the @embedded-collation@ settings under respective database node is not used.
(Eric: curre...
Ovidiu Maxiniuc
10:48 AM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> Roger Borrello wrote:
> > Just confirming... making the changes in my @directory.xml@ (fro...
Roger Borrello
10:41 AM Feature #5491: custom locale/collation implementations
Roger Borrello wrote:
> Just confirming... making the changes in my @directory.xml@ (from @en_GB_iso88591_fwd_basic@...
Ovidiu Maxiniuc
10:26 AM Feature #5491: custom locale/collation implementations
Just confirming... making the changes in my @directory.xml@ (from @en_GB_iso88591_fwd_basic@ to @en_GB&#64;iso88591_f... Roger Borrello
10:09 AM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > Do I need to update @directory.xml@ and @p2j.cfg.xml@ for a pro...
Eugenie Lyzenko
10:07 AM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> Ovidiu Maxiniuc wrote:
> > In fact, I am a bit against this line which forces the schema to...
Ovidiu Maxiniuc
10:00 AM Feature #5491: custom locale/collation implementations
Eugenie Lyzenko wrote:
> Do I need to update @directory.xml@ and @p2j.cfg.xml@ for a project to use @nl_NL@cp1252_fw...
Ovidiu Maxiniuc
09:08 AM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> Roger Borrello wrote:
> > If/when there is a change, will there be another conversion requ...
Eugenie Lyzenko
10:54 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> In fact, I am a bit against this line which forces the schema to be used only with the sp...
Eric Faulhaber
10:53 PM Feature #5491: custom locale/collation implementations
Eugenie Lyzenko wrote:
> Are you planning to add more conversion related changes tomorrow in this area?
As far ...
Eric Faulhaber
10:50 PM Feature #5491: custom locale/collation implementations
Ovidiu,
I have started new conversion for @12709@. Just because I need to verify everything from scratch again.
...
Eugenie Lyzenko

07/22/2021

02:01 PM Feature #5491: custom locale/collation implementations
Guys,
If another conversion is planned during next day please let me know within next 21 hour. This will ensure th...
Eugenie Lyzenko
11:08 AM Feature #5491: custom locale/collation implementations
Roger Borrello wrote:
> If/when there is a change, will there be another conversion required? I was about to update ...
Ovidiu Maxiniuc
10:36 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> Sorry for the churn. Had I anticipated these seemingly simple name changes would be so probl...
Roger Borrello

07/21/2021

04:27 PM Feature #5491: custom locale/collation implementations
Yes, if the new locale was added to @/etc/locale.gen@. This needs to be added in our wiki. Ovidiu Maxiniuc
03:28 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> There is a good news, though. The process works each time (I've created the locale then t...
Eric Faulhaber
03:15 PM Feature #5491: custom locale/collation implementations
Yes, that puzzled me too. Notice that after the @.@ there is no @_@ character. The @_@ in out locale names are droppe... Ovidiu Maxiniuc
03:06 PM Feature #5491: custom locale/collation implementations
I don't understand. The dot is used in many of the standard locale names.
For example, @locale -a@ on my system cu...
Eric Faulhaber
03:03 PM Feature #5491: custom locale/collation implementations
That seems fine. Greg Shah
03:02 PM Feature #5491: custom locale/collation implementations
Sorry for the silence of the last hours. I continued my experiments. It looks like the underscore (@_@) is NOT the is... Ovidiu Maxiniuc
03:01 PM Feature #5491: custom locale/collation implementations
@[@ and @]@ are probably not great since they have meaning in other languages including in shell script.
If the hy...
Greg Shah
03:01 PM Feature #5491: custom locale/collation implementations
Sorry for the churn. Had I anticipated these seemingly simple name changes would be so problematic, I would have had ... Eric Faulhaber
02:58 PM Feature #5491: custom locale/collation implementations
If/when there is a change, will there be another conversion required? I was about to update the customer's environmen... Roger Borrello
02:08 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> I'm ok with @en_US.iso88591FWDbasic@, but I have a feeling @locale-gen@ lowercases everythin...
Eugenie Lyzenko
01:59 PM Feature #5491: custom locale/collation implementations
I'm ok with @en_US.iso88591FWDbasic@, but I have a feeling @locale-gen@ lowercases everything after the dot, so I was... Eric Faulhaber
01:49 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> OK, so the underscores are a problem with Linux. The @@@ symbols are a problem with H2. Shou...
Eugenie Lyzenko
01:19 PM Feature #5491: custom locale/collation implementations
OK, so the underscores are a problem with Linux. The @@@ symbols are a problem with H2. Should we just get rid of all... Eric Faulhaber
01:04 PM Feature #5491: custom locale/collation implementations
Roger Borrello wrote:
> Are those steps only required in an upgrade scenario? Perhaps the steps should be mentioned ...
Ovidiu Maxiniuc
12:53 PM Feature #5491: custom locale/collation implementations
Roger Borrello wrote:
> Are those steps only required in an upgrade scenario?
Or if you want to clean up the syst...
Eugenie Lyzenko
12:46 PM Feature #5491: custom locale/collation implementations
Are those steps only required in an upgrade scenario? Perhaps the steps should be mentioned in the Wiki in a separate... Roger Borrello
10:26 AM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > Why the step 2 above is required if it run once again on step 4...
Eugenie Lyzenko
09:44 AM Feature #5491: custom locale/collation implementations
Eugenie Lyzenko wrote:
> Why the step 2 above is required if it run once again on step 4? I used almost the same sce...
Ovidiu Maxiniuc
10:02 AM Feature #4022: upgrade to a newer PostgreSQL release
I was able to alleviate the error by going back to PL/Java 1.5.6, and abandoning the 1.6.2 version. Good riddance (fo... Roger Borrello

07/20/2021

06:12 PM Feature #5491: custom locale/collation implementations
My import completed for @nl_NL.cp1252_fwd_basic@ based cluster.
The DB looks good.
Eugenie Lyzenko
05:58 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> I used a fresh Ubuntu installation to create the PG cluster with @nl_NL.cp1252_fwd_basic@ C...
Eugenie Lyzenko
05:27 PM Feature #5491: custom locale/collation implementations
I used a fresh Ubuntu installation to create the PG cluster with @nl_NL.cp1252_fwd_basic@ Collation and Ctype. Howeve... Ovidiu Maxiniuc
05:15 PM Feature #5491: custom locale/collation implementations
Greg Shah wrote:
> Why are you changing @/etc/default/locale@? Wouldn't this make the JVM start with @LANG=en_US.is...
Ovidiu Maxiniuc
02:05 PM Feature #5491: custom locale/collation implementations
Why are you changing @/etc/default/locale@? Wouldn't this make the JVM start with @LANG=en_US.iso88591_fwd_basic@? ... Greg Shah
01:06 PM Feature #5491: custom locale/collation implementations
Yes, but the problem is that you need to run step 3 the first. If @/usr/lib/locale/nl_NL.cp1252_fwd_basic@ is not gen... Ovidiu Maxiniuc
12:54 PM Feature #5491: custom locale/collation implementations
Well, now I also have the required cluster:... Eugenie Lyzenko
12:39 PM Feature #5491: custom locale/collation implementations
Eugenie Lyzenko wrote:
> The only way to have cluster created for me is to add the following locale:
> @sudo locale...
Eugenie Lyzenko
12:36 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> Ovidiu, are the obsolete FWD locales perhaps being generated due to changes you've made in t...
Ovidiu Maxiniuc
12:35 PM Feature #5491: custom locale/collation implementations
The only way to have cluster created for me is to add the following locale:
@sudo localedef -c -f CP1252 -i nl_NL.cp...
Eugenie Lyzenko
12:28 PM Feature #5491: custom locale/collation implementations
Ovidiu, are the obsolete FWD locales perhaps being generated due to changes you've made in the list of supported loca... Eric Faulhaber
12:26 PM Feature #5491: custom locale/collation implementations
Eugenie Lyzenko wrote:
> Please clarify what do you mean by "1st step" above?
I mean to do the entire process on a ...
Ovidiu Maxiniuc
12:20 PM Feature #5491: custom locale/collation implementations
To be clear: all the FWD-related custom locales with @p2j_basic@ or @@@ in the names are obsolete and should no longe... Eric Faulhaber
12:16 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> It works again for me:
> [...]
>
> I need to do a clean-up and recreate it all from the...
Eugenie Lyzenko
11:57 AM Feature #5491: custom locale/collation implementations
It works again for me:... Ovidiu Maxiniuc
10:44 AM Feature #5491: custom locale/collation implementations
Things are a bit more complicated:
The dot (@.@) cannot be used in H2. It is replaced in the background with @_@.
T...
Ovidiu Maxiniuc
10:06 AM Feature #5491: custom locale/collation implementations
Do we have to use different locale name formats for PG and H2? Why not to use some simpler name, say @nl_NL.cp1252@? ... Eugenie Lyzenko
09:57 AM Feature #5491: custom locale/collation implementations
I am also investigating the issue. But I could not find a reason what is wrong.
I edited @edit /etc/locale.gen@ a...
Ovidiu Maxiniuc
09:38 AM Feature #5491: custom locale/collation implementations
Ovidiu: The documentation seems to be incorrect. I think Eugenie is doing exact what is listed but it does not work. Greg Shah
09:15 AM Feature #5491: custom locale/collation implementations
Greg Shah wrote:
> Isn't the @.@ a problem in SQL?
I think the @pg_createcluster@ just drops everything after @.@...
Eugenie Lyzenko
08:21 AM Feature #5491: custom locale/collation implementations
Isn't the @.@ a problem in SQL? Greg Shah
08:10 AM Feature #5491: custom locale/collation implementations
The strange thing is happening:
1. I have both system locales installed, @nl_NL@CP1252@basic@FWD@ and @nl_NL.cp1252_...
Eugenie Lyzenko

07/17/2021

09:04 AM Feature #5491: custom locale/collation implementations
The H2/Java collation names and Linux/PostgreSQL locale names were unified as described above.
Also, I think I updat...
Ovidiu Maxiniuc

07/15/2021

06:30 PM Feature #4022: upgrade to a newer PostgreSQL release
I have been trying to get my test system going using PostgreSQL 13 for updated client code, and when I get to the PL/... Roger Borrello
04:46 PM Feature #5491: custom locale/collation implementations
@en_US.iso88591_fwd_basic@ will be then. Ovidiu Maxiniuc
04:36 PM Feature #5491: custom locale/collation implementations
I prefer the underscores. Greg Shah
04:03 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> OK, Ovidiu, so it sounds like we need to keep this setting in @p2j.cfg.xml@. But for consist...
Eric Faulhaber
04:02 PM Feature #5491: custom locale/collation implementations
OK, Ovidiu, so it sounds like we need to keep this setting in @p2j.cfg.xml@. But for consistency from the user's pers... Eric Faulhaber
03:38 PM Feature #5491: custom locale/collation implementations
Constantin Asofiei wrote:
> Do you mean this in @p2j.cfg.xml@?
> [...]
>
> The reason was to emit the @set colla...
Constantin Asofiei
02:31 PM Feature #5491: custom locale/collation implementations
Do you mean this in @p2j.cfg.xml@?... Constantin Asofiei
02:18 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> If we need to keep the collation setting in @p2j.cfg.xml@, we can accept either form. I th...
Eric Faulhaber
02:16 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> I did not think about it that way, but it makes sense. We can use the @@@, too in this ca...
Eric Faulhaber
01:30 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> Do you recall what that is used for?
According to bzr, it was added in 2010, with the _"sup...
Ovidiu Maxiniuc
12:35 PM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> This seems to fit in both worlds.
I don't think it really fits in the Linux world. The...
Eric Faulhaber
12:24 PM Feature #5491: custom locale/collation implementations
H2 identifies the locale using its name this way:... Ovidiu Maxiniuc
11:22 AM Feature #5491: custom locale/collation implementations
Ovidiu Maxiniuc wrote:
> The SPI only provides a sort order. The language and country are probably irrelevant here...
Eric Faulhaber
11:01 AM Feature #5491: custom locale/collation implementations
From #5034:
The SPI only provides a sort order. The language and country are probably irrelevant here, but they ar...
Ovidiu Maxiniuc

07/14/2021

07:21 PM Feature #5491: custom locale/collation implementations
I assume that setting would be in the form @<language>_<COUNTRY>@, e.g., @en_US@, @en_GB@, etc. To compose an @embedd... Eric Faulhaber
06:58 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> ...
> Do we already have comparable settings in the directory (or programmatic defaults) fo...
Eric Faulhaber
06:53 PM Feature #5491 (WIP): custom locale/collation implementations
We need to simplify the configuration of the locale/collation in use for databases, including the @_temp@ database. I... Eric Faulhaber

07/10/2021

04:29 AM Bug #5540: can't query meta info for meta tables
@testcases/uast/dump_meta_info.p@ reads all the @_File@ records and outputs some meta information about all tables (f... Constantin Asofiei
04:27 AM Bug #5540 (New): can't query meta info for meta tables
Constantin Asofiei

07/07/2021

03:44 PM Feature #5491: custom locale/collation implementations
Code review 3821c/12640:
The changes in this revision look good.
I took another look at @gen-locale.p@ and I di...
Eric Faulhaber
09:10 PM Feature #5491: custom locale/collation implementations
Done. Committed revision 12640.
I also updated the extractor procedure to create new files with fixed header/title a...
Ovidiu Maxiniuc
10:20 AM Bug #5521 (Closed): [java] java.io.EOFException on import when no PSC footer
Greg Shah
10:15 AM Bug #5521: [java] java.io.EOFException on import when no PSC footer
My @ant import.db@ of the database went off without any issues (aside from my PL/Java getting upgraded to 1.6.2 again). Roger Borrello
06:22 AM Bug #5521 (Test): [java] java.io.EOFException on import when no PSC footer
Greg Shah
06:22 AM Bug #5521: [java] java.io.EOFException on import when no PSC footer
Code Review Task Branch 3821c Revison 12640
The changes look good.
Greg Shah
09:07 PM Bug #5521 (WIP): [java] java.io.EOFException on import when no PSC footer
The issue should be fixed in revision 12640. Ovidiu Maxiniuc

07/06/2021

08:14 AM Bug #5521: [java] java.io.EOFException on import when no PSC footer
Some details are available in the related thread starting at #5034-814.
From Greg:
>I don't think we should be s...
Roger Borrello
08:12 AM Bug #5521 (Closed): [java] java.io.EOFException on import when no PSC footer
Roger Borrello

07/05/2021

06:51 PM Feature #4022: upgrade to a newer PostgreSQL release
I noticed that @postgresql-10-pljava@ was on the auto-update list, and pljava was upgraded at 5pm to @1.6.2-2.pgdg20.... Roger Borrello
04:59 PM Feature #5491: custom locale/collation implementations
Please change the @title@ in the @LC_IDENTIFICATION@ section of the @en_GB@ locale definitions to say, "Great Britain... Eric Faulhaber
04:26 PM Feature #5491: custom locale/collation implementations
No, I'll close it after review of this current batch. As we create more locales/collators over time, we can reopen it... Eric Faulhaber
04:20 PM Feature #5491 (Review): custom locale/collation implementations
Do we keep this task open for adding new collations? Ovidiu Maxiniuc

07/02/2021

05:13 PM Support #5183: database collation
Ovidiu Maxiniuc wrote:
> The listing you obtained is pretty much the one we currently have in @locale/xx_XX@ISO8859-...
Eric Faulhaber
10:27 AM Support #5183: database collation
The listing you obtained is pretty much the one we currently have in @locale/xx_XX@ISO8859-1@basic@FWD@ and @src/com/... Ovidiu Maxiniuc
10:06 AM Support #5183: database collation
Eric,
The space character (@0x20@, or @32@ decimal) is incorrectly listed in the 2nd position. This is because the c...
Ovidiu Maxiniuc
04:43 AM Support #5183: database collation
h2. Comparison of OE ISO-8859-1 basic collation vs. PostgreSQL ISO-8859-1 default collation (en_US)
I created ISO-...
Eric Faulhaber
03:33 PM Bug #5512: Java todate(text) UDF returns incorect value
@public.todate('06302001')@ returns '2001-06-29' which doesn't look correct. Igor Skornyakov
03:32 PM Bug #5512 (New): Java todate(text) UDF returns incorect value
Igor Skornyakov
02:01 PM Feature #4022: upgrade to a newer PostgreSQL release
Constantin Asofiei wrote:
> Please read the above as 'unofficial steps'. There may be a better way to do this, but ...
Roger Borrello
01:57 PM Feature #4022: upgrade to a newer PostgreSQL release
The release notes for PL/Java https://tada.github.io/pljava/releasenotes.html indicate the moved to the Java 9 module... Roger Borrello
01:56 PM Feature #4022: upgrade to a newer PostgreSQL release
I went through setting up PL/Java 1.6.2 last week (with psql 12.7). 1.6.2 does require Java 11 - it is compiled as s... Constantin Asofiei
01:45 PM Feature #4022: upgrade to a newer PostgreSQL release
OK, don't install PL/Java through apt. This is actually untested, so you are breaking new ground here.
Does PL/Jav...
Eric Faulhaber
01:09 PM Feature #4022: upgrade to a newer PostgreSQL release
Roger Borrello wrote:
> So getting to the Java 11 uninstall... it also uninstall pljava. So when this is done, I'll ...
Roger Borrello
01:05 PM Feature #4022: upgrade to a newer PostgreSQL release
I started reading the fine manual at PL/Java: https://tada.github.io/pljava/install/install.html
When I ran @pg_co...
Roger Borrello
02:12 AM Feature #4022: upgrade to a newer PostgreSQL release
Roger Borrello wrote:
> What are your thoughts on the @/opt/pljava/install.sql@ script (attached) in terms of when/h...
Eric Faulhaber
12:08 AM Feature #4022: upgrade to a newer PostgreSQL release
What are your thoughts on the @/opt/pljava/install.sql@ script (attached) in terms of when/how to run it? I don't see... Roger Borrello
10:07 PM Feature #4022: upgrade to a newer PostgreSQL release
Roger Borrello wrote:
> ...
> Eric and I went over quite a few things, but it doesn't appear that the Java 11 I hav...
Eric Faulhaber
08:25 PM Feature #4022: upgrade to a newer PostgreSQL release
Greg suggested I create a new task in database, but this task looks well suited for the issues related to installing ... Roger Borrello
01:53 PM Bug #5511: todate(text) Java UDF throws strange exception
Java UDF @todate(text)@ throws an exception @SQL Error [XX000]: ERROR: java.lang.NoClassDefFoundError: com/goldencode... Igor Skornyakov
01:52 PM Bug #5511 (New): todate(text) Java UDF throws strange exception
Igor Skornyakov

07/01/2021

12:54 PM Support #5183: database collation
> @locale -a@ does not list them
If @localedef@ was successful there should be new locale files. If that is the c...
Greg Shah
12:44 PM Support #5183: database collation
Do you have @/usr/share/i18n/charmaps/CP1252.gz@? If so, @gunzip@ it. I think @locale-gen@ just runs @localedef@ unde... Eric Faulhaber
12:35 PM Support #5183: database collation
Eric Faulhaber wrote:
> These were the specific lines I added to @/etc/locale.gen@, based on some Googling:
> [...]...
Ovidiu Maxiniuc
12:20 PM Support #5183: database collation
Roger Borrello wrote:
> A general question about the use of a custom locale. The database for an existing applicatio...
Eric Faulhaber
12:17 PM Support #5183: database collation
Ovidiu Maxiniuc wrote:
> Eric,
> I have not tried to use the @en_US.cp1252@ locale until now. Only the custom local...
Eric Faulhaber
11:39 AM Support #5183: database collation
A general question about the use of a custom locale. The database for an existing application would need to be droppe... Roger Borrello
11:33 AM Support #5183: database collation
Eric,
I have not tried to use the @en_US.cp1252@ locale until now. Only the custom locales. However, when I try to d...
Ovidiu Maxiniuc
03:07 AM Support #5183: database collation
Ovidiu, I need your help.
In any of your encoding testing lately, have you been able to create a database cluster ...
Eric Faulhaber

06/30/2021

09:20 PM Feature #5491: custom locale/collation implementations
Sorry, I do not know how these task properties has changed. I did not do it on purpose :(. Ovidiu Maxiniuc
09:15 PM Feature #5491: custom locale/collation implementations
Eric Faulhaber wrote:
> Ovidiu, please update the FWD documentation with the new approach to installation and config...
Ovidiu Maxiniuc

06/29/2021

04:14 PM Feature #5491: custom locale/collation implementations
Ovidiu, please update the FWD documentation with the new approach to installation and configuration. Specifically, th... Eric Faulhaber

06/28/2021

03:20 PM Feature #5491 (WIP): custom locale/collation implementations
Yes. They would be identified by:
| PostgreSQL | @en_US@CP1252@basic@FWD@,
@en_GB@CP1252@basic@FWD@ and
@nl_NL@CP1...
Ovidiu Maxiniuc
02:47 PM Feature #5491: custom locale/collation implementations
OK, understood.
Then shouldn't we mirror the same approach for the @p2jspi.jar@? This may avoid confusion.
Greg Shah
02:20 PM Feature #5491: custom locale/collation implementations
It is a bit more complicated than that.
We need to keep the lang/land prefix. This is used within the locale script...
Ovidiu Maxiniuc
02:05 PM Feature #5491: custom locale/collation implementations
Then perhaps we should not have @en_US@CP1252@FWD@, @en_GB@CP1252@FWD@ and @nl_NL@CP1252@FWD@ but instead just @basic... Greg Shah
01:36 PM Feature #5491: custom locale/collation implementations
I investigated the content of the @convmap.cp@ on my Windows test machine and I found the following collations availa... Ovidiu Maxiniuc
10:10 AM Feature #5491: custom locale/collation implementations
Indeed, at first I thought that using different CPs will automatically imply a specific sorting order since I did not... Ovidiu Maxiniuc
07:07 AM Feature #5491: custom locale/collation implementations
> The language and country parameters are not relevant (for what I know)
Are you saying that we've never found any...
Greg Shah
 

Also available in: Atom