Recent content by Gangrel

Hmm, I posted this already, but it doesn't appear to be on the site? Quick question. If I have a one MB file in Windows, and store it as a BLOB, does that BLOB item take up one MB of space in DB2? Basically, what I'm wondering is if our 3.8 GBs worth of files will take up 3.8 GBS of disk...

It's stored as quot; We also appear to have some issues with some characters getting translated into little boxes..... I assume this if from users using special charactes on a french keyboard. (we're in Canada) Is this a safe assumption

This is probably very simple, but I'm not sure how to handle this. We have a app built on jsp, beans, struts, and uses DB2 as the database. users enter information on forms, which gets stored on the DB. If they use quotes on the form, it gets stored as &quot. Is this a DB2 thing that does...

Thanks alot PHV!

Ok, i found on Google (but not in the Access help menu) that there is supposedly a HEX function that returns the character represented. To test it out, I try: SELECT * FROM TMSG WHERE MSG_TXT_FRC Like '*HEX(41)*'; and get no results, even though that hex characer is in the database. I...

Sorry to ressurect an old thread, but I have recently created a few more of these and have some more questions. I need to replace some apostrophe characters that are unique to French keyboards. When I try this: UPDATE TMSG SET MSG_TXT_FRC = Replace([MSG_TXT_FRC], ''(the french one', ''')...

The only functions I have in Access 2000 here at work are to convert Hex into Decimal, or Hex into Octal, or into Binary. Nothing shows up in my help menu but those.

Here's my problem. I have a table that is used to create a text file that is loaded onto an os390 mainframe, which is EBCIDAC. In my table, there are some characters that do not translate properly during the conversion from Unicode to EBCIDAC. What I need to so is search for these characters...

The app is a JSP app running under jboss, so on the server side..... (unless my coffee hasn't kicked in yet)

What's the easiest way to accompish this? We currently have the following code that takes what the user enters into a text box and retrieves the item. <html:link href="" titleKey="itracker.web.header.quickview.alt" onclick="document.lookupForm.submit();" styleClass="headerLinks">...

Ok, I got it working now. Thanks a lot for the help guys. If I could send a beer over the 'net, I'd buy a round!

I have tried both with and without the outside parenthesis. And I have just created a query in Access, and am running it. I am wondering if I"m simply confusing Access and it's trying to set all my TXT_MSG_FRC field to a string of "REPLACE(etc etc...")

Ok, I've tried the following and it doesn't work: UPDATE TMSG SET MSG_TXT_FRC = (REPLACE(MSG_TXT_FRC,"BN","dog")); I don't have a WHERE clause because I want to go through every row in the table. When I try this query, it tells me it's going to change 4701 rows (my table), but then when I...

Randell, does the replace function work for one character, or the whole field? update tblname set fldname = replace(fldname, "oldval", "newvale") where <criteria> almost looks to me like it will wipe out the entire field. Or maybe I'm just thinking wrong.....

I would like to be able to do a find and replace on a text field in a database table automatically. In Excel, there appears to be a macro where you can do this, but I don't see the same thing in Access? I'm not replacing the whole field, just a single character to "clean" my data. Any...