Re: [HACKERS] FreeBSD ICU was Win32 unicode vs ICU

2006-03-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-08-25 04:53:47 +1000:
 Kevin McArthur Wrote:
 
  Should the postgresql project also be looking at CLDR for 
  cross-platform unicode support?
 
 Afaict, from the ICU website, ICU too uses CLDR.
 Why reinvent the wheel?

Just a thought: PHP is under a BSD-like (Apache-style) license.
Does that mean they're going to rewrite ICU under their license?

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [HACKERS] FreeBSD ICU was Win32 unicode vs ICU

2006-03-26 Thread Martijn van Oosterhout
On Sun, Mar 26, 2006 at 02:13:28PM +0200, Roman Neuhauser wrote:
  Afaict, from the ICU website, ICU too uses CLDR.
  Why reinvent the wheel?
 
 Just a thought: PHP is under a BSD-like (Apache-style) license.
 Does that mean they're going to rewrite ICU under their license?

Near as I can tell, ICU is under a BSD like licence.

http://dev.icu-project.org/cgi-bin/viewcvs.cgi/*checkout*/icu/license.html

Perhaps they are compatable.

Have a nice day,
-- 
Martijn van Oosterhout   kleptog@svana.org   http://svana.org/kleptog/
 Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
 tool for doing 5% of the work and then sitting around waiting for someone
 else to do the other 95% so you can sue them.


signature.asc
Description: Digital signature


Re: [HACKERS] FreeBSD ICU was Win32 unicode vs ICU

2006-03-26 Thread Roman Neuhauser
# kleptog@svana.org / 2006-03-26 15:53:24 +0200:
 On Sun, Mar 26, 2006 at 02:13:28PM +0200, Roman Neuhauser wrote:
   Afaict, from the ICU website, ICU too uses CLDR.
   Why reinvent the wheel?
  
  Just a thought: PHP is under a BSD-like (Apache-style) license.
  Does that mean they're going to rewrite ICU under their license?
 
 Near as I can tell, ICU is under a BSD like licence.

I got confused by the Gnome LocaleProject reference earlier in the
thread, sorry for the noise.
 
 http://dev.icu-project.org/cgi-bin/viewcvs.cgi/*checkout*/icu/license.html
 
 Perhaps they are compatable.

They should be, as the ICU license is basically the MIT license
tightened to have the same set of requirements as the new BSD
license.

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991

---(end of broadcast)---
TIP 6: explain analyze is your friend


[HACKERS] FreeBSD ICU was Win32 unicode vs ICU

2005-08-24 Thread Kevin McArthur

I was reviewing this thread about its lack of collation support in freebsd.

As some of you may or may not know the PHP project is also currently working 
heavily on unicode support. (For PHP6)


I had the chance to ask Andrei Zmievski of the php project about their 
support for unicode. The key items are as follows.


StormTide with the new unicode support, is there any support for unicode 
collation

andrei StormTide, there will be
StormTide is it imported by the platform or custom done for php
StormTide (cuz freebsd seeems to have issues with its collation support)
andrei StormTide, not OS-dependent
andrei StormTide, uses CLDR

Should the postgresql project also be looking at CLDR for cross-platform 
unicode support?


http://www.unicode.org/cldr/

Kevin McArthur
Digifonica Canada

- Original Message - 
From: Tom Lane [EMAIL PROTECTED]

To: Magnus Hagander [EMAIL PROTECTED]
Cc: pgsql-hackers@postgresql.org; Palle Girgensohn [EMAIL PROTECTED]
Sent: Tuesday, August 23, 2005 9:03 AM
Subject: Re: [HACKERS] Win32 unicode vs ICU



I wrote:

(Just looking at it again, the code in convert_string_to_scalar is
pretty bogus for multibyte encodings in any case.  Possibly we need to
rethink the whole approach.)


After studying this some more, I think the code is really so bogus for
any non-ASCII situation that it's probably not worth worrying about
too much.  It's effectively assuming that the output of strxfrm() is
still in an ASCII-superset encoding ... but I don't see anything in
strxfrm's API that guarantees any such thing.

As long as strxfrm() doesn't fail completely for Windows Unicode,
I'd recommend just leaving this alone.  As previously noted, the
worst that can happen is an estimation error that's bounded by the
histogram bin size anyhow.

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings




---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [HACKERS] FreeBSD ICU was Win32 unicode vs ICU

2005-08-24 Thread John Hansen
Kevin McArthur Wrote:

 Should the postgresql project also be looking at CLDR for 
 cross-platform unicode support?

Afaict, from the ICU website, ICU too uses CLDR.
Why reinvent the wheel?

... John

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly