-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello all! It's recently come to my attention that ColdFusion is not entirely happy about dealing with Unicode characters from MS SQL server. It seems as tho CF 4.0.1 can handle nvarchar's in CFQUERY's, but dies with Unicode in CFSTOREDPROC's. At least according to a CF-Talk post from the archives (not verified by myself). It would also seem that CF 4.5.1 chokes and turns blue on any kind of Unicode anywhere. I had problems converting to 4.5.1 several months ago, and tho Allaire's tech support never mentioned any problem with nvarchar's even after 4 or 5 hours on the phone, there were indeed nvarchar's in the database in question. I have a hunch that might have been the root of my problems. That said, I'm hoping to make another attempt at upgrading to CF 4.5.1 / Win2k. My beloved baby (a *very* stable, *very* profitable server) must unfortunately be moved off-site for better bandwidth, and I'd REALLY like to have Win2k on that box so I can TermServe in if necessary, etc. I'm more than a little apprehensive at trying this again seeing as last time cost us a week of downtime, but.... It's a necessary evil I'm afraid. Now that I have something to go on regarding fixing the numerous PCode and other completely whacked out errors we received from our last update attempt, I *think* converting all of the ntext & nvarchar fields in our databases may allow CF 4.5.whatever to run without (or with fewer) problems. I am however left with a few questions that I hope some kind soul(s) could answer for me. The Burning Questions (as in if I don't get these answered, my boss is gonna burn me at the stake...): 1) Can anyone confirm or deny that CF 4.5.x is unable to handle Unicode text from an MS SQL 7 database? If anyone else has had the same problems we had (ridiculous PCode errors, server hangs, etc.) after moving from CF 4.0.1 to CF 4.5.x against an MS SQL 7 database w/ lots of nvarchar fields, I'd love to hear about your pain. Likewise, if anyone is running a reasonably high volume site on CF 4.5.1 against MS SQL 7 with lots of nvarchar's WITHOUT any problems, I'd love to hear about that too. If anyone would simply like to reply off list to me ([EMAIL PROTECTED]) with their configuration and their success or failure, I'd be happy to summarize the results and post said summary for the list's benefit. 2a) Assuming that my nvarchar's are indeed the source of my trouble (o/~ Nobody knows the troubles I've seen... ~\o), then I'm stuck with several very large, very sensitive, very I'm-dead-if-I-screw-this-up kind of databases on my hands. And of course, said databases have TONs of potentially ColdFusion offending Unicode fields. Going through all of the DB's and changing nvarchar to varchar in Enterprise Manager doesn't sound like my idea of a fun or employment preserving task. Especially since EM (in it's infinite wisdom) attempts to truncate the field length to 50 every time you change from nvarchar to varchar. All I need to do is mess *one* of those up by saving the table without resetting the proper field length, and I'll only *wish* I was a dead man. 2b) So... Are there any utilities, SQL scripts, scrolls of magical spells, etc. out there that can go through a database and change all fields from one datatype to another without changing the field length? Has anyone else in my unfortunate position been compelled to write such a beast? It sounds technically simple (look in sysobjects for all user tables, get their description w/ sp_help, then construct an ALTER TABLE statement to properly change the field types, rejoice and enjoy much cf_beer), but my brain is a little too.... fried (This is your brain on CF. Any questions?) to produce such a miraculous bit of code at the moment. So can anyone help me out? Your help, suggestions, sympathy, and (at worst case) job offers would be much appreciated! Best regards, Zac Bedell ======================================== Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original message in any replies -- I get a lot of email every day, and I have a REALLY bad memory... So I don't always remember everything that was said. Thanks! -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com> iQA/AwUBOhrVwKvhLS1aWPxeEQJ9qwCglHIC1YU1ZSv70Il8AEwB2rxx0E8AoJvO /x3Xkkb4//MNYgtm6vKYj8NI =bcVy -----END PGP SIGNATURE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
