Hi, On Fri, Aug 14, 2009 at 5:36 PM, Kingsley Idehen<kide...@openlinksw.com> wrote: > Aldo Bucchi wrote: >> >> Hi, >> >> On Fri, Aug 14, 2009 at 7:17 AM, Aldo Bucchi<aldo.buc...@gmail.com> wrote: >> >>> >>> On Aug 13, 2009, at 22:51, Aldo Bucchi <aldo.buc...@gmail.com> wrote: >>> >>> >>>> >>>> Hi Ivan, >>>> >>>> On Thu, Aug 13, 2009 at 10:21 PM, Ivan >>>> Mikhailov<imikhai...@openlinksw.com> wrote: >>>> >>>>> >>>>> Hello Aldo, >>>>> >>>>> I will extend the list of supported column types soon, to fully support >>>>> NVARCHAR, LONG NVARCHAR and ANY. After that, the only unsupported type >>>>> remaining will be VARBINARY (and LONG VARBINARY). >>>>> >>>> >>>> OK. And what about using " Function-Based IRI Classes" in the >>>> meantime. Should that work? >>>> >>> >>> It does not :( >>> >> >> What happens if I cast the nvarchar to varchar in the views? >> This obviously breaks bijection as I might be loosing data. >> But, I see no other way around. >> >> CREATE VIEW X.X.Concept >> AS >> SELECT >> cast ( concept_id as varchar ) as id, >> FROM X.X.concept_table >> ; >> >> and then create an IRI class that can be used like so >> >> x:concept ( concept.id ) >> >> Note that I am 100% certain that the data in this column is simply >> alphanumeric w/no strange chars. Basically, IDs that may look like >> "980YUHS877" >> >> Of course, changing the column type in the source database is impossible. >> >> Thanks, >> A >> >> >> >>>> >>>> We really need this ASAP. So any workarounds are welcome. >>>> Here's the dataflow so you get a bigger picture. >>>> >>>> * Data lives in Sybase 12.5.x >>>> * Comes in via respective UDA driver ( unicode, because some chars in >>>> other columns may be latin ) >>>> * We link the remote datasource into VDB >>>> * Create a SQL View to consolidate entities >>>> * Then create RDFViews. Here's where we need the IRI class on a PK >>>> which ends up being an nvarchar >>>> >>>> Thanks, >>>> A >>>> >>>> >>>>> >>>>> Best Regards, >>>>> >>>>> Ivan Mikhailov >>>>> OpenLink Software >>>>> http://virtuoso.openlinksw.com >>>>> >>>>> On Thu, 2009-08-13 at 19:01 -0400, Aldo Bucchi wrote: >>>>> >>>>>> >>>>>> Hi, >>>>>> >>>>>> I'm trying to create an iri class that takes an nvarchar field as >>>>>> input. >>>>>> Virtuoso spits: >>>>>> >>>>>> 22023 The datatype "nvarchar" is not supported in CREATE IRI CLASS... >>>>>> >>>>>> How can I go around this? >>>>>> We need unicode support because there might be latin characters flying >>>>>> around. >>>>>> ( we think we need ). >>>>>> >>>>>> Thanks, >>>>>> A >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> -- >>>> Aldo Bucchi >>>> skype:aldo.bucchi >>>> http://www.univrz.com/ >>>> http://aldobucchi.com/ >>>> >>>> PRIVILEGED AND CONFIDENTIAL INFORMATION >>>> This message is only for the use of the individual or entity to which it >>>> is >>>> addressed and may contain information that is privileged and >>>> confidential. >>>> If >>>> you are not the intended recipient, please do not distribute or copy >>>> this >>>> communication, by e-mail or otherwise. Instead, please notify us >>>> immediately by >>>> return e-mail. >>>> >> >> >> >> > > Just realized that's what your attempting above. > > I read mails bottom up sometimes :-)
We need wave like stuff! > > -- > > > Regards, > > Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen > President & CEO OpenLink Software Web: http://www.openlinksw.com > > > > > -- Aldo Bucchi skype:aldo.bucchi http://www.univrz.com/ http://aldobucchi.com/ PRIVILEGED AND CONFIDENTIAL INFORMATION This message is only for the use of the individual or entity to which it is addressed and may contain information that is privileged and confidential. If you are not the intended recipient, please do not distribute or copy this communication, by e-mail or otherwise. Instead, please notify us immediately by return e-mail.
