Posts by Jader Dias • 495 points
7 posts
-
1
votes1
answer392
viewsA: Time on timestamp
The function of Perl localtime accepts a parameter time which is a Unix Epoch in the seconds drive. In Perl localtime(time()) is the same thing as localtime() Knowing this, to get the result minus…
-
16
votes3
answers1952
viewsQ: How to remove a website from Google?
Had found some instructions on the internet, to remove a google site, referred to an old version of webmasters tools, that there was this feature, but I can not find this option in the current…
googleasked Jader Dias 495 -
3
votes2
answers428
viewsA: How to open a Unicode file inside a zip?
The response of the gringos in the SO was The reason you are seeing this error is because you are trying to mix bytes with Unicode. The argument for split should also be byte-string: >>>…
-
4
votes5
answers2566
viewsA: Is it recommended to use Linq instead of SQL?
Yes, the use of LINQ forces the programmer to protect their code against SQL injection. Yes, LINQ is sometimes slower. But there is more than one way to detect and solve these problems. Yes, I’ve…
-
7
votes2
answers428
viewsQ: How to open a Unicode file inside a zip?
I tried to with zipfile.ZipFile("5.csv.zip", "r") as zfile: for name in zfile.namelist(): with zfile.open(name, 'rU') as readFile: line = readFile.readline() print(line) split = line.split('\t') but…
-
4
votes3
answers882
viewsA: How to insert an extended value into a table in a varbinary column?
Response from Martin Smith INSERT INTO [YourTable] (YourFileColumn) VALUES ( CAST(REPLICATE(CAST(0XFF AS VARBINARY(MAX)), 100 * 1024 * 1024) AS VARBINARY(MAX)))…
-
4
votes3
answers882
viewsQ: How to insert an extended value into a table in a varbinary column?
A table has a varbinary(max) column, I need it to have a 400MB input of data in this column. How I create this data? The Insert statement has to have the data in full or I can use a loop or a…