char set (not yet)

Ricardo Strausz <[email protected]> Fri, 9 May 2003 21:06:53 -0500
Newsgroups gmane.comp.web.webobjects.eof
Message-ID <[email protected]>
Hola otra vez!

My problem is still there...
Let me be more specific now:
I have a Sybase (11.5) database running inside an HP Vectra XU on top  
of Windows NT 4.0 with about 0.5 GB of data. Such a data was generated  
by several apps running inside HP Apollos (712/60) on top of NeXTSTEP  
3.3 (with EOF 1.1). All these in Mexico city, so my users use spanish  
characters in all the strings;  in particular, lots of accented ones.
I am in the process of migrating all these into Macs on top of OSX(S).  
So I am using EO's JDBC (from WO 5.2) in order to get the connectivity  
to the db, but all my strings shows wrong... in both directions: if,  
from my Mac, I fetch some data captured in the NeXT side, it shows rare  
characters; and the other way arround.

I realy nead some help in this isue!!!!!!!

I had try several hints (from this and other lists) but nothing seem to  
work...

HELP


On jueves, mayo 1, 2003, at 11:20 America/Mexico_City, Chuck Hill wrote:

> Ricardo Strausz wrote:
> >
>
>> On the other hand, I did not understud the second...
>> How do I construct the URL by hand?
>
> It is just a java.lang.String.  Consult your JDBC driver documentation  
> to determine the proper format and contents.  Once you have that  
> figured out, look here for the code to get your EOModel to use it:
>
> http://www.omnigroup.com/search-bin/webobjects- 
> dev?Search=ModelAddedNotification
>
> Chuck
>
>
>
>> On miƩrcoles, abri 30, 2003, at 17:35 America/Mexico_City, Chuck Hill  
>> wrote:
>>> Dino,
>>>
>>> I'm not sure what you are asking.  I'm not aware that EOModels have a
>>> character set.  Unless you want to use these characters for attribute
>>> names.  In that case, I have no idea.  :-)
>>>
>>> Or do you mean that you want to add an additional entry to the JDBC  
>>> URL so
>>> that the database handles the code page conversion correctly?  You  
>>> might be
>>> able to do this by opening the EOModel, selecting the root node, and
>>> opening the inspector.  You can add new key  
>>> (sybaseClientCharacterSet) /
>>> value (cp850) pairs there.  That might do the right thing.  Or that  
>>> might
>>> do the same thing as what you have already tried.
>>>
>>> Otherwise you can construct the JDBC URL by hand and update the  
>>> connection
>>> dictionary in the EOModel as it is loaded.
>>>
>>> Sorry, not much help here.
>>>
>>>
>>> Chuck
>>>
>>>
>>> At 05:03 PM 30/04/2003 -0600, Ricardo Strausz wrote:
>>>
>>>>> Does some one know how to change the character set of an eomodel??
>>>>> Any help will be very welcome
>>>>
>>>>
>>>> In previous versions of EOF (e.g. 1.0), the .eomodel was a flat  
>>>> file.
>>>> If one added, in the connection dictionary, a line like
>>>> sybaseClientCharacterSet = cp850;
>>>> (I am using sybase 10.5)
>>>> one changed the char set... since my users are Mexicans, they nead  
>>>> to
>>>> use some characters as q,i,| and other accented ones.
>>>>
>>>> I tried to do this in the flat-file inside the boundle .eomodel but  
>>>> it
>>>> did not work.
>>>>
>>>> Any Idea?
>>>>
>>>>
>>>>
>>>> Dino
>>>> http://homepage.mac.com/strausz
>>>> _______________________________________________
>>>> webobjects-dev mailing list | [email protected]
>>>> Help/Unsubscribe/Archives:
>>>
>>> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
>>>
>>>> Do not post admin requests to the list. They will be ignored.
>>>>
>>>
>>> -- 
>>>
>>> Chuck Hill                                 [email protected]
>>> Global Village Consulting Inc.              
>>> http://www.global-village.net
>
>
> -- 
>
> Chuck Hill                                 [email protected]
> Global Village Consulting Inc.              
> http://www.global-village.net
>
> Progress is the mother of all problems.
> - G. K. Chesterton
>
>

Dino
http://homepage.mac.com/strausz