| Author |
Topic |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
 Posted - 2005-05-04 : 04:56:15
|
| Most of the characters are stored in a Single byte but some Japanese Characters requires Two Bytes to store Characters. Is there anyway to store those characters in a Single byte? I am looking for the query or any other tool. Is this possible with SQL Server or any other programming Languages?MadhivananFailing to plan is Planning to fail |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-04 : 05:05:51
|
well if a char is stored in 2 bytes to display properly then i don't see how you'd store it in one byte and still display it properly.Go with the flow & have fun! Else fight the flow  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-04 : 05:16:35
|
| Yes, thats what I am looking for. Do you think there is anyway to do this?MadhivananFailing to plan is Planning to fail |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-04 : 05:28:00
|
| honestly, no.at least i don't see how...Go with the flow & have fun! Else fight the flow |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-05-04 : 07:34:21
|
| Stop, step back, take a minute and think about what you are asking.- Jeff |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-04 : 07:36:18
|
| To aid you in this, I've highlighted the relevant phrase from your post:but some Japanese Characters requires Two Bytes to store Characters. Is there anyway to store those characters in a Single byte? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-04 : 07:38:45
|
| My question is some characters need two bytes but is it possible to compress them so that to be stored in a single byte?MadhivananFailing to plan is Planning to fail |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-04 : 07:40:15
|
| Again, read your post, read Jeff's advice, the answer is pretty obvious. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-04 : 07:44:54
|
| No I am not too expert in SQL like you and dont know how to do itSo you say this is not possible in SQL isnt it?MadhivananFailing to plan is Planning to fail |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-04 : 07:47:51
|
| No, it's not possible, and it has nothing to do with SQL knowledge. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-04 : 07:53:33
|
| robvolk, Do you think there is any tool or software that will convert Double bytes to Single byte?MadhivananFailing to plan is Planning to fail |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-04 : 07:54:57
|
| What part of "it cannot be done" are you having trouble with? |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-05-04 : 09:19:02
|
| madhivanan -- do you understand how the laws of the universe work? Do you call the milk company up and ask them if there is a way to fit 2 cups of milk in a 1 cup container? Do you think there must be a way to fit 2 cars in a 1 car garage?- Jeff |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-04 : 09:23:40
|
| Jeff, autually I wanted to know if there is method to compress the character to fit to One byte as Files are zipped by using Winzip or any other toolMadhivananFailing to plan is Planning to fail |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-04 : 09:27:14
|
well first you must understand how zip works  so no you can't "zip" it. it's already at the minimum.Go with the flow & have fun! Else fight the flow |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-05-04 : 09:29:21
|
Do you know how file compression works? It does not copy 2 bytes into 1 byte. Differnet algorithms work different ways, but one way is scanning large amounts of data and building a table of all patterns that are repeated, and then storing those patterns only once and referencing them instead of storing the redundant data over and over. Compression doesn't work if you want to compress 2 bytes into 1, it is too small of an amount. Do me a favor -- create a text file on your PC in notepad, call it "test.txt" and then enter the following text into it:This is a test of compression. Save it, and note that it is 30 bytes. Now compress it with winZip. Report back here with how big the ZIP file comes out.- Jeff |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-04 : 09:38:28
|
| Jeff, After zipping that file, the size increases to 144 bytes from 30 bytesMadhivananFailing to plan is Planning to fail |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-05-04 : 09:41:50
|
| Did you draw any conclusions from that exercise and/or from the information we've given you?- Jeff |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-04 : 09:46:05
|
| yes, everything is not always possible MadhivananFailing to plan is Planning to fail |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-04 : 12:32:06
|
| This is like watching a seinfeld episode...Brett8-) |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-04 : 13:02:18
|
I Figured out George and Jerry but Mladen is definitly not kramer or numan! JimUsers <> Logic |
|
|
|
Next Page
|
Double Byte to Single Byte