Re: IDS.2000

Anyway, I hope your eyebrows grow back again. If I might borrow the phrase. From: rwilson@ntsource.com (Rob Wilson) > >Leonids.Voroncovs@dati.lv wrote: >: Rob Wilson wrote: > >: > A bug is something that causes unexpected behavior. This is expected, > >: 1. There is implicit cast from NCHAR to CHAR, >: but there isn't cast from NVARCHAR to CHAR. >: This behavior You call expected? > >Only that without a cast defined none is performed. > >: Where may be a problem to cast NCHAR but do not cast NVARCHAR? > >No idea. > >: 2. The casting mentioned works fine with 7.3x, >: but doesn't works with 9.2x. >: This behavior You call expected? > >Expected may be a bit harsh, I find it unsurprising. I think 7.3x just >tried to cast as it could and I would not be surprised if this only >worked based on a translation file existing for the database locale to >C. > >: Where is promised 100% compatibility? > >Agreed. Treat it like a bug. >(Everyone loves marketing promises) > >: > You can either create a cast for >: > nvarchar to char (RTFM for syntax) or > >: You can't create casting from built-in type to build-in type. >: You should RTFM first. > >I should have, yes. > >: > CREATE FUNCTION my_proc (p LVARCHAR) > >: This means big redeveloping as mentioned in previous message. > >It may be the only work around, call tech support and see if they have >better ideas. (Or maybe someone around here does.) > >: > Rob Wilson > >: Leonid Vorontsov > > > >-- >Rob Wilson >rwilson@ntsource.com >(foot removed, have a nice day.) > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com